<?php
include "connectStoreDB.php";

$prod=$_GET["prod"];
$price=$_GET["price"];

$sql="UPDATE products SET price=$price WHERE product_id=$prod";

mysqli_query($conn, $sql);
echo "$prod's price updated!";

//close connection
mysqli_close($conn);

//redirect back to admin page
header("location:admin.php");
?>